Importing CSV files in MS Excel

The bulk IP address lookup tool has an option to save the location data in CSV format This is a short guide on viewing the downloaded IP address location data in Microsoft Excel, Apache OpenOffice, LibreOffice, Google Sheets, Office 365 (Office Live) and more.

Visit ipapi.co/bulk

• Enter the IP addresses that you want to lookup
• Select CSV format from the dropdown menu
• Press Submit
• Save the output as location.csv

Bulk IP Lookup

Microsoft Excel

Open the file location.csv in Excel. If you have saved the file with a different extension e.g. location.txt or if Excel does not recognize the format, you’ll see a dialog like the screenshot below (Text Import Wizard)

• Select the radio box titled Delimited
• From the File origin dropbox menu select 65001 : Unicode(UTF-8)
• Check the box titled My data has headers
• Press Next

Text Import Wizard — Step 1

3. In the next step of the import wizard (screenshot below)

• Under Delimiters option, uncheck all except Comma. The reason is that this is a CSV file (aka Comma-Separated Values i.e. the values are delimited by a comma).
• In the Text qualifiers dropdown menu, select double quotes (the default option)
• Hit Finish after this step (no need to press Next)

You should be able to visualize the data split into columns in MS Excel now.

IP Location as CSV in Excel

LibreOffice

• Open the file in LibreOffice Calc
• Select the options below in the Text Import wizard. The important onesbeing the Character Set (Unicode UTF-8) and Separator should be a Comma.
• Press OK

Google Sheets

• Go to Google Drive and upload the location file
• If your file is labelled with a .csv extension, Google Sheets will automatically open the file in a spreadsheet like display. Alternatively you can open a new blank sheet and then go to File > Import
• Select the uploaded location file
• In the import options, the separator should be Comma and set No for “convert text to numbers..” option.

Google Sheets Import File

IP Location in Google Sheets