Multiple columns of excel only shown as 1 column

0 votes

One of my coworker's excel files (*.csv) contains several rows and columns, as can be seen in the image below.

However, there is only one column under her Office 365 account. This implies that even if she switches computers while using the same account, this will still occur.

And the identical Excel file on other computers (not hers) does not have this problem.

Could someone kindly offer advice?

enter image description here

Jan 29, 2023 in Others by Kithuzzz
• 38,000 points
566 views

1 answer to this question.

0 votes
Data is separated into CSV (Comma Separated Value) files by Comma, Semicolon, etc. In some regions, Excel is configured differently. Semicolons are used as delimiters in place of commas, the same as in Europe. Excel will read a CSV file correctly if the operating system's regional settings match the delimiter used in the file.
answered Jan 29, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How to divide data in excel into 4 columns whose sum is almost equal to 1/4 of the sum of all values/

5049 is the sum of all numbers, ...READ MORE

answered Feb 7, 2023 in Others by narikkadan
• 63,600 points
820 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,600 points
495 views
0 votes
1 answer

Removing duplicates from Excel rows by adding values of some columns

Copy the first three columns to another ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
920 views
0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,600 points
751 views
0 votes
1 answer

How To Use VBA To Share Excel File With Fellow Office User?

PowerApps were referenced; if you have a ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,600 points
1,324 views
0 votes
1 answer

Tab creation failure using macro

Export By Name From Multiple Worksheets Option Explicit Sub ...READ MORE

answered Apr 2, 2023 in Others by Kithuzzz
• 38,000 points
336 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,246 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,020 points
1,109 views
0 votes
1 answer

How to split only one column to multiple rows while copying rest of the columns along the way?

Try this: =DROP(REDUCE(0,REDUCE(0,C2:C3,LAMBDA(a,x,VSTACK(a,CONCAT ...READ MORE

answered Feb 6, 2023 in Others by narikkadan
• 63,600 points
445 views
0 votes
1 answer

Is there any way in python to auto-correct spelling mistake in multiple rows of an excel files of a single column?

Use Spellchecker for doing your stuff: import pandas ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 63,600 points
2,075 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP