Hi Guys,
I recently used a table that I copied and pasted from Excel. It rendered correctly in the desktop version but it is quite messy in the mobile version.
Is there a way I can fix this?
Thanks
Chris
FYI I did try to edit the html as one of your developers previously suggested:
<div style=”overflow-x:auto;”>
<table>
…
</table>
But it didn’t effect any change to the appearance.
Here is my website post with the table. Maybe one of the problems is I copied and pasted the table from Excel. I did it that way because I didn’t see any “table” option in the editing menu for the new post.
https://www.modernvedicastrology.com/research-study-the-mars-pluto-opposition-and-the-stock-market/
Hello Chris!
Did you build the table in Gutenberg? Please ensure you enter the values with space for the mobile, too. Otherwise, it will just look like that.
Thank you!
Hi Bettina,
No, I did not build the table in Gutenberg. Can you provide a link that explains how to build tables in Gutenberg? Thank you!
If I understand you correctly, do I need to enter the html code twice — once in desktop version and then also in the mobile version of the website?
Regards.
Hello Chris!
Here is a video: https://www.youtube.com/watch?v=M7MCuBqv5_M
If you use code, then the code should also be responsive, and not added twice.
Thank you!
Hello Chris!
It should work well and be responsive.
Thank you!
I’ll check it out and let you know. 🙂
According to the video, tables made with block editor will not work with Excel or csv data. That’s a problem since I am trying to import Excel data to my website. Do you know of the best way I can do this? I have a lot of data (7 columns, 35 rows). I hope I don’t have to add it all manually. That will take forever!
Hello Chris!
Manual Copy-Paste the information there:
1. Open Your CSV or Excel File: Open your file in a spreadsheet editor (e.g., Microsoft Excel, Google Sheets).
2. Copy the Data: Select and copy the range of cells you want to add.
3. Paste into Gutenberg: Go to your post or page in the Gutenberg editor, add a Table block, and paste the data directly into it. Gutenberg will automatically create the rows and columns.
Thank you!
OK I’ll try that. Thanks. But how does the Gutenberg editor know where to put the table within my post?
My problem is that I don’t see the Gutenberg editor in my post page. Is this something I have to do in the tagdiv editor?
Hello Chris!
Edit a post with Gutenberg: https://app.screencast.com/6sGrEJc0QJOTH
Add the table where you want: https://app.screencast.com/GbwTC1d0Tu4pI -> https://app.screencast.com/y8axTehGw854t
With the help of these arrows, you can place it where you need it on your post content: https://app.screencast.com/Q6DAccpaCTMa7
I hope that helps you!
Thank you!
Thank you for your help on this. I really appreciate it.
But when I click on the edit button, I go to the post editor page. I do not go to the Gutenberg block editor. Is it possible I don’t have it installed yet?
Also when I go to the list of posts, all my post titles are displayed vertically, like this:
S
A
M
P
L
E
T
I
T
L
E
O
C
T
O
B
E
R
2
0
2
4
E
D
I
T
It’s very strange!
Just FYI, I realize that I have only been using the Classic editor. I think I don’t have the Block editor installed. Oh no!
Actually, I’m not sure which editor I’m using. My editor looks a lot like the Classic editor but there is no “table” button in my toolbar.
But I know the Block editor isn’t working. I wonder if it’s been disabled somehow. I’ve heard this can happen for various reasons.
Hello Chris!
Uncheck some options from here to display less information: https://app.screencast.com/253G5SdB9sbUC
Uninstall the Classic Editor and try again.
Thank you!
Thank you Bettina. My post listing is better now.
And thanks for the tip about the Classic editor. Actually what I did was to change its setting so I can change editors between block and classic. Before it was set to classic only.
I think I’ve finally got it now.
I’m grateful for your help. Have a great day! 🙂
Hello Chris!
I’m glad that I could help you!
Have a nice day!
Unfortunately, I haven’t yet created a table using copied and pasted Excel data. This is harder than I thought.
After I open a new table in the block editor, the problem is where does the copied Excel data go? I tried pasting it to the top left hand cell in the table, and it only filled that cell with a very compressed and lengthy string of data. All other cells were empty. My table is comprised of 8 columns and 37 rows.
Is it possible to easily import Excel spreadsheet data into a WordPress table or do I need a special plug-in?
Chris
Hello Chris!
No. It’s wrong. You should paste (CTRL + V) when you click here: https://app.screencast.com/y8axTehGw854t?conversation=RtFV7msf4y2hOsezQ1gjUX
You shouldn’t create a table. The table will be created automatically after you paste the info.
Thank you!
Thank you for your continuing support, Bettina.
OK I followed your instructions.
1) I copied my Excel data.
2) I opened block editor and clicked the blue “create table” button
3) when it opened, I pasted the data.
4) the data is now all mixed up without any formatting.
What should I do now?
On an unrelated matter, can you tell me if Newspaper supports “embed scripts” with Javascript tags? These apparently render much faster than iframes.
Hello Chris!
You shouldn’t click on the blue button, but click on the background of that element to be selected and paste it there.
Thank you!
Sorry, I don’t understand where to click. Which element do you mean?
Could you explain the sequence once again, please?
Hello Chris!
Click exactly on the white background here: https://app.screencast.com/y8axTehGw854t?conversation=RtFV7msf4y2hOsezQ1gjUX
Thank you!
After opening a table block on a blank post (“Auto Draft”), I clicked on the white background exactly as you said. But it opened without any formatting. Just a big compressed mass of data. According to the labels at the bottom of the page it was in the paragraph mode. “Post>Paragraph”
It is not resolving into a table form. It is not working according to your instructions. I will send you a screenshot via email if you like.
Btw, this is a known issue with some WordPress themes as data does not get formatted into a table but instead is formatted into a paragraph.
AFter searching online, I found someone who wrote that first pasting the Excel data into Google Sheets and then recopying the Google spreadsheet data and THEN pasting it into the block editor worked. And it worked for me too.
Of course, I would prefer to skip this Google third step if possible. Do you know why it only works with Google Sheets?
