Extracting then importing a Csv.gz file into Excel/SPSS...problem recognising the text qualifier?

user_10598515 0
Viewed 2283

I am using a file from Insideairbnb.com for my thesis. It is a csv.gz file so first I extracted it using the 'Archive Utility' for Mac.

It is comma delimited and uses double quotes as the text qualifier which I specified in the Import popup but Excel/SPSS is still delimitating at the commas within the text.

It is a large file that includes full airbnb descriptions and reviews which are contained in double quotations. Unfortunately, there are many commas within the strings of text. I have never seen a csv file with this format but I believe it was put together correctly because I have seen Insideairbnb cited for data in quite a few scholarly articles.

I have included a link to pictures of a snippet of the data on the SPSS import window. If anyone knows how to go about importing this I would greatly appreciate your feedback :)

Thank you in advance!

[[1]: https://i.stack.imgur.com/Iy3dA.png][1][SPSS screenshot] [1]: https://i.stack.imgur.com/i7KcG.png[SPSS screenshot 2][1]

spss import csv gzip excel
2 Answers

I agree with @sarawhite's comment above; if this is a one-time problem there are a couple things I would try.

  1. open the .csv in excel, and if it looks right, save it and then try to import it in SPSS, or saveas an .xlsx file and import that (although there can be nonsense with string variables in either scenario)

OR

  1. open in notepad++ and look at the raw data. you can find and replace double line breaks fairly easily.
user_51989100

I copy-pasted the data into Notepad++ yesterday, then converted it to ANSI and copy-pasted it back into Excel. Yesterday, it worked, but today it doesn't...

Anyways, maybe this thread is helpful for people with the same question. I will try again at a later point in time.

user_149975660
Related