Hi! I downloaded the file from “Worldcities Dataset”, in my case there are only Excel files in the download section. How did you get the CSV version? Thank you
Hey Bruno, I just downloaded the dataset once again (via the large download button at the bottom of the “Basic” column on the website) and I still got both a .csv and .xlsx file. Please do make sure, you’re checking the file extension and not just the icon assigned to those files, as .csv usually gets the Excel icon too. If you still got no .csv file, you can convert it yourself with your spreadsheet program of choice. With Google Spreadsheets for example, you’d open your file and then go to “File” -> “Download” -> “Comma Separated Values (.csv)”
Unlock with Patreon
Hi! I downloaded the file from “Worldcities Dataset”, in my case there are only Excel files in the download section. How did you get the CSV version? Thank you
Hey Bruno, I just downloaded the dataset once again (via the large download button at the bottom of the “Basic” column on the website) and I still got both a .csv and .xlsx file. Please do make sure, you’re checking the file extension and not just the icon assigned to those files, as .csv usually gets the Excel icon too. If you still got no .csv file, you can convert it yourself with your spreadsheet program of choice. With Google Spreadsheets for example, you’d open your file and then go to “File” -> “Download” -> “Comma Separated Values (.csv)”